Parallel Hierarchical Evaluation of Tranitive Closure Queries

نویسندگان

  • Maurice A. W. Houtsma
  • Filippo Cacace
  • Stefano Ceri
چکیده

This paper presents a new approach to parallel computation of transitive closure queries using a semantic data fragmentation. We assume that tuples of a large base relation denote edges in a graph, which models a transportation network; we propose a fragmentation algorithm which produces the partitioning of the base relation into several fragments such that any fragment corresponds to a subgraph. Any two fragments are considered as either adjacent or nonadjacent; two fragments are adjacent when the corresponding subgraphs have a nonempty intersection. One fragment, called high-speed fragment, collects all edges which guarantee maximum speed, these edges correspond to highways or to high-speed inter-city trains. Thus, the fragmentation algorithm induces a hierarchical relationship between the high-speed fragment and all other fragments. With this fragmentation, any query about paths connecting two nodes can be answered by using just the fragments in which nodes are located and the high-speed fragment. In general, if each fragment is managed by a distinguished processor, then the query can be answered by three processors working in parallel. This schema can be recursively applied to generate an arbitrary number of hierarchical levels.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Exploring Load Balancing in Parallel Processing of Recursive Queries

Recent work on load balancing has connrmed its importance when one wants to achieve good performances during the actual evaluation of parallel database queries. Existing work mostly focuses on the join processing for parallel relational databases. We are interested here in more complex queries, such as recursive ones. The main diierence is that, in the latter case, the work due to a task cannot...

متن کامل

Estimating recursive query costs for various parallel environments

We introduce a recursive query evaluation method whose main goal is to obtain recursive query cost estimate without performing the query. In particular, we show that the execution estimate of the parallel processing of recursive queries can be done by exploiting the characteristics of the database profile during the evaluation process for request optimization. As many recursive queries involve ...

متن کامل

An Overview of Parallel Strategies for Transitive Closure on Algebraic Machines

1 I n t r o d u c t i o n Over the past few years, recursive queries have emerged as an important new class of complex queries. These queries enable solving classical database problems, such as the bill-of-mat¢rial (finding all transitive components of a given part). This type of problems is classically managed in commercial applications by embedding queries within programming language interfac...

متن کامل

Implementing Generalized Transitive Closure in the Paradise Geographical Information System

The generalized transitive closure operator can be used to ask and answer a number of sophisticated queries on a database which is viewed as a directed graph. These queries cannot be expressed in SQL or relational algebra and neither can they be answered by commercially available relational or object-oriented database systems. In this report we describe the design and implementation of the gene...

متن کامل

Transitive Closure and the LOGA+-Strategy for its Efficient Evaluation

One of the key problems when extending relational database query languages to include deductive capabilities, is to provide them with efficient methods for answering recursive queries. During the last few years many algorithms have been proposed to deal with transitive closure computation of a relation. In this paper, we discuss some important criteria for developing transitive closure algorith...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1991